/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-23 00:13:38
*/


-- ----------------------------
-- Table structure for tb3500
-- ----------------------------
DROP TABLE [dbo].[tb3500]
GO
CREATE TABLE [dbo].[tb3500] (
[DivisionID] varchar(20) NOT NULL ,
[TranMonth] int NULL ,
[TranYear] int NULL ,
[ConvertDecimal] tinyint NULL ,
[UnitPriceDecimal] tinyint NULL ,
[PercentDecimal] tinyint NULL ,
[QuantityDecimal] tinyint NULL ,
[IsDiscount] tinyint NULL ,
[IsCommission] tinyint NULL ,
[IsInventoryCommonName] tinyint NULL ,
[IsNotRepeatLinkNo] tinyint NULL ,
[IsPriceControl] tinyint NULL ,
[IsQuantityControl] tinyint NULL ,
[OPriceTypeID] varchar(20) NULL ,
[IsPicking] tinyint NULL ,
[MaterialRate] decimal(28,8) NULL ,
[IsNotDebit] tinyint NULL ,
[IsConvertUnit] tinyint NULL 
)


GO


